﻿CREATE TABLE [dbo].[CardPayments] (
    [CardPaymentId]     INT             IDENTITY (1, 1) NOT NULL,
    [BookingId]         INT             NOT NULL,
    [PaymentMethodCode] VARCHAR (10)    NOT NULL,
    [CardNo]            VARCHAR (50)    NOT NULL,
    [NameOnCard]        VARCHAR (50)    NOT NULL,
    [CardTypeCode]      VARCHAR (10)    NOT NULL,
    [CardExpiryDate]    DATE            NOT NULL,
    [PaidAmount]        DECIMAL (18, 2) NOT NULL,
    [PaymentDate]       DATE            NULL
);

